package com.ruoyi.orderview.mapper;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;


import java.util.List;
import java.util.Map;
/**
 * Author 许家森
 * Date 2022/2/22
 * Email 3448324670@qq.com
 */
@Mapper
public interface StromaChartsMapper {
    //用于查询stroma的所有表

    //查询stroma_purchase表中的purchase_time为x，purchase_amount为y
    public List<Map<Object,Object>> selectStromaPurchase(@Param("o") String origintime, @Param("e") String endtime);
    //查询stroma_consume表中的consume_time为x，consume_amount为y
    public List<Map<Object,Object>> selectStromaConsume(@Param("o") String origintime, @Param("e") String endtime);
    //查询stroma_consume_temporary表中的consume_time为x，consume_amount为y
    public List<Map<Object,Object>> selectStromaConsumeTemporary(@Param("o") String origintime, @Param("e") String endtime);
    //查询stroma_return表中的return_time为x，return_amount为y
    public List<Map<Object,Object>> selectStromaReturn(@Param("o") String origintime, @Param("e") String endtime);
    //查询stroma_amount表中的update_time为x，storage_amount为y
    public List<Map<Object,Object>> selectStromaUpdate(@Param("o") String origintime, @Param("e") String endtime);
    //查询stroma_purchase表中的purchase_time为x，total_price为y
    public List<Map<Object,Object>> selectStromaPurcahseTotal(@Param("o") String origintime, @Param("e") String endtime);
    //查询stroma_amount表中的查询时间段的初始值，即离时间段最近的一条数据
    public Map<Object,Object> selectStromaUpdateOrigin(@Param("o") String origintime, @Param("e") String endtime);


}
